using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VICC_WBBST
    {
        public DataRow Convert2ICC_WBBST(DataRow dwInput, string ITXDBVERSION, bool IsConvert = false)
        {
            DataSet SResult = new DataSet();
            SResult = QueryICC_WBBST(dwInput, 0);
            DataRow dwReturn = null;
            if (SResult.Tables[0].Rows.Count > 0)
            {
                dwReturn = SResult.Tables[0].Rows[0];
            }
            else
            {
                dwReturn = SResult.Tables[0].NewRow();
            }
            switch (ITXDBVERSION)
            {
                case "YGR":
                    #region=========
         dwReturn["ICCDAT"] = " ".PadRight(0 ); 
         dwReturn["WBBMANDANT"] = " ".PadRight(2 ); 
         dwReturn["WBBRWKRS"] = " ".PadRight(2 ); 
         dwReturn["WBBRWLFD"] = " ".PadRight(6 ); 
         dwReturn["WBBPOS"] = " ".PadRight(4 ); 
         dwReturn["WBBWERK"] = " ".PadRight(3 ); 
         dwReturn["WBBABT"] = " ".PadRight(3 ); 
         dwReturn["WBBKUNDNR"] = " ".PadRight(8 ); 
         dwReturn["WBBSTKNR"] = " ".PadRight(12 ); 
         dwReturn["WBBWAKZ"] = " ".PadRight(1 ); 
         dwReturn["WBBART"] = " ".PadRight(20 ); 
         dwReturn["WBBDESS"] = " ".PadRight(10 ); 
         dwReturn["WBBCOLORIT"] = " ".PadRight(10 ); 
         dwReturn["WBBFARBE"] = " ".PadRight(10 ); 
         dwReturn["WBBBESCHICH"] = " ".PadRight(10 ); 
         dwReturn["WBBVAR"] = " ".PadRight(2 ); 
         dwReturn["WBBKOLL"] = " ".PadRight(5 ); 
         dwReturn["WBBVKART"] = " ".PadRight(24 ); 
         dwReturn["WBBVKFARBE"] = " ".PadRight(10 ); 
         dwReturn["WBBARTABW"] = " ".PadRight(1 ); 
         dwReturn["WBBARTKUNDNR"] = " ".PadRight(8 ); 
         dwReturn["WBBENTWKZ"] = " ".PadRight(1 ); 
         dwReturn["WBBSSTKLG"] = " ".PadRight(0 ); 
         dwReturn["WBBSGEW"] = " ".PadRight(0 ); 
         dwReturn["WBBSBRT"] = " ".PadRight(0 ); 
         dwReturn["WBBISTKLG"] = " ".PadRight(0 ); 
         dwReturn["WBBIGEW"] = " ".PadRight(0 ); 
         dwReturn["WBBIBRT"] = " ".PadRight(0 ); 
         dwReturn["WBBBRGEW"] = " ".PadRight(0 ); 
         dwReturn["WBBDM"] = " ".PadRight(0 ); 
         dwReturn["WBBVOL"] = " ".PadRight(0 ); 
         dwReturn["WBBIGEWKZ"] = " ".PadRight(1 ); 
         dwReturn["WBBIANZ"] = " ".PadRight(0 ); 
         dwReturn["WBBMABRT1"] = " ".PadRight(0 ); 
         dwReturn["WBBMASTKLG1"] = " ".PadRight(0 ); 
         dwReturn["WBBMABRT2"] = " ".PadRight(0 ); 
         dwReturn["WBBMASTKLG2"] = " ".PadRight(0 ); 
         dwReturn["WBBMABRT3"] = " ".PadRight(0 ); 
         dwReturn["WBBMASTKLG3"] = " ".PadRight(0 ); 
         dwReturn["WBBMABRT4"] = " ".PadRight(0 ); 
         dwReturn["WBBMASTKLG4"] = " ".PadRight(0 ); 
         dwReturn["WBBMABRT5"] = " ".PadRight(0 ); 
         dwReturn["WBBMASTKLG5"] = " ".PadRight(0 ); 
         dwReturn["WBBINDAT"] = " ".PadRight(0 ); 
         dwReturn["WBBINBSTMTR"] = " ".PadRight(0 ); 
         dwReturn["WBBINBSTKG"] = " ".PadRight(0 ); 
         dwReturn["WBBIPREIS"] = " ".PadRight(0 ); 
         dwReturn["WBBWARSCH"] = " ".PadRight(8 ); 
         dwReturn["WBBWDATUM"] = " ".PadRight(0 ); 
         dwReturn["WBBWSCHICHT"] = " ".PadRight(1 ); 
         dwReturn["WBBWMNRKRS"] = " ".PadRight(2 ); 
         dwReturn["WBBWMLFDNR"] = " ".PadRight(4 ); 
         dwReturn["WBBWMPOS"] = " ".PadRight(2 ); 
         dwReturn["WBBRE"] = " ".PadRight(0 ); 
         dwReturn["WBBRENETTO"] = " ".PadRight(0 ); 
         dwReturn["WBBREVGUET"] = " ".PadRight(0 ); 
         dwReturn["WBBRS"] = " ".PadRight(0 ); 
         dwReturn["WBBRSNETTO"] = " ".PadRight(0 ); 
         dwReturn["WBBRSVGUET"] = " ".PadRight(0 ); 
         dwReturn["WBBVE"] = " ".PadRight(0 ); 
         dwReturn["WBBVENETTO"] = " ".PadRight(0 ); 
         dwReturn["WBBVEVGUET"] = " ".PadRight(0 ); 
         dwReturn["WBBVS"] = " ".PadRight(0 ); 
         dwReturn["WBBVSNETTO"] = " ".PadRight(0 ); 
         dwReturn["WBBVSVGUET"] = " ".PadRight(0 ); 
         dwReturn["WBBANZTEILE"] = " ".PadRight(1 ); 
         dwReturn["WBBVERSION"] = " ".PadRight(1 ); 
         dwReturn["WBBTAX"] = " ".PadRight(3 ); 
         dwReturn["WBBZENSUR"] = " ".PadRight(1 ); 
         dwReturn["WBBZENSURKZ"] = " ".PadRight(1 ); 
         dwReturn["WBBUBRT"] = " ".PadRight(0 ); 
         dwReturn["WBBZAFOLGE"] = " ".PadRight(3 ); 
         dwReturn["WBBNAFOLGE"] = " ".PadRight(3 ); 
         dwReturn["WBBZLNR"] = " ".PadRight(15 ); 
         dwReturn["WBBAUFMSL"] = " ".PadRight(2 ); 
         dwReturn["WBBZUSAM"] = " ".PadRight(2 ); 
         dwReturn["WBBMAART"] = " ".PadRight(1 ); 
         dwReturn["WBBPACKTYP"] = " ".PadRight(4 ); 
         dwReturn["WBBROLLR"] = " ".PadRight(1 ); 
         dwReturn["WBBAUFMPOS"] = " ".PadRight(4 ); 
         dwReturn["WBBKONFKZ"] = " ".PadRight(1 ); 
         dwReturn["WBBKETTELN"] = " ".PadRight(1 ); 
         dwReturn["WBBSHSTK1"] = " ".PadRight(0 ); 
         dwReturn["WBBSHBRT1"] = " ".PadRight(0 ); 
         dwReturn["WBBSHSTKLG1"] = " ".PadRight(0 ); 
         dwReturn["WBBSHSTK2"] = " ".PadRight(0 ); 
         dwReturn["WBBSHBRT2"] = " ".PadRight(0 ); 
         dwReturn["WBBSHSTKLG2"] = " ".PadRight(0 ); 
         dwReturn["WBBSHSTK3"] = " ".PadRight(0 ); 
         dwReturn["WBBSHBRT3"] = " ".PadRight(0 ); 
         dwReturn["WBBSHSTKLG3"] = " ".PadRight(0 ); 
         dwReturn["WBBSHSTK4"] = " ".PadRight(0 ); 
         dwReturn["WBBSHBRT4"] = " ".PadRight(0 ); 
         dwReturn["WBBSHSTKLG4"] = " ".PadRight(0 ); 
         dwReturn["WBBSHSTK5"] = " ".PadRight(0 ); 
         dwReturn["WBBSHBRT5"] = " ".PadRight(0 ); 
         dwReturn["WBBSHSTKLG5"] = " ".PadRight(0 ); 
         dwReturn["WBBSTKNRK"] = " ".PadRight(12 ); 
         dwReturn["WBBLO"] = " ".PadRight(2 ); 
         dwReturn["WBBLB"] = " ".PadRight(2 ); 
         dwReturn["WBBKZ"] = " ".PadRight(1 ); 
         dwReturn["WBBLP"] = " ".PadRight(8 ); 
         dwReturn["WBBAUFBKZ"] = " ".PadRight(1 ); 
         dwReturn["WBBGEBNR"] = " ".PadRight(8 ); 
         dwReturn["WBBGEBPOS"] = " ".PadRight(3 ); 
         dwReturn["WBBSPSTA"] = " ".PadRight(2 ); 
         dwReturn["WBBSPGRD"] = " ".PadRight(2 ); 
         dwReturn["WBBERLKZ"] = " ".PadRight(1 ); 
         dwReturn["WBBAUFTYP"] = " ".PadRight(1 ); 
         dwReturn["WBBAUFKRS"] = " ".PadRight(2 ); 
         dwReturn["WBBAUFLFD"] = " ".PadRight(6 ); 
         dwReturn["WBBAUFPOS"] = " ".PadRight(3 ); 
         dwReturn["WBBTP"] = " ".PadRight(4 ); 
         dwReturn["WBBFOLGE"] = " ".PadRight(2 ); 
         dwReturn["WBBAFOLGEVON"] = " ".PadRight(3 ); 
         dwReturn["WBBRAFOLGE"] = " ".PadRight(3 ); 
         dwReturn["WBBMAFOLGE"] = " ".PadRight(3 ); 
         dwReturn["WBBRSTKLG"] = " ".PadRight(0 ); 
         dwReturn["WBBRGEW"] = " ".PadRight(0 ); 
         dwReturn["WBBLGAE"] = " ".PadRight(0 ); 
         dwReturn["WBBGEWAE"] = " ".PadRight(0 ); 
         dwReturn["WBBPOOL"] = " ".PadRight(1 ); 
         dwReturn["WBBAUTZU"] = " ".PadRight(1 ); 
         dwReturn["WBBWDUPOS"] = " ".PadRight(2 ); 
         dwReturn["WBBRBENID"] = " ".PadRight(8 ); 
         dwReturn["WBBRDATB"] = " ".PadRight(0 ); 
         dwReturn["WBBRDAT"] = " ".PadRight(0 ); 
         dwReturn["WBBRBEM"] = " ".PadRight(15 ); 
         dwReturn["WBBRKUNDNR"] = " ".PadRight(8 ); 
         dwReturn["WBBDPART"] = " ".PadRight(11 ); 
         dwReturn["WBBDPART2"] = " ".PadRight(11 ); 
         dwReturn["WBBZUSTAND"] = " ".PadRight(4 ); 
         dwReturn["WBBFARBN"] = " ".PadRight(2 ); 
         dwReturn["WBBSPKZ"] = " ".PadRight(1 ); 
         dwReturn["WBBCUKZ"] = " ".PadRight(1 ); 
         dwReturn["WBBDISPOART"] = " ".PadRight(20 ); 
         dwReturn["WBBDISPOVAR"] = " ".PadRight(2 ); 
         dwReturn["WBBAUSFFRB"] = " ".PadRight(0 ); 
         dwReturn["WBBAUSFGRI"] = " ".PadRight(0 ); 
         dwReturn["WBBAUSFQUAL"] = " ".PadRight(0 ); 
         dwReturn["WBBQUALST"] = " ".PadRight(1 ); 
         dwReturn["WBBQPKT"] = " ".PadRight(0 ); 
         dwReturn["WBBQPKTH"] = " ".PadRight(0 ); 
         dwReturn["WBBQPKTL"] = " ".PadRight(0 ); 
         dwReturn["WBBQPKTLH"] = " ".PadRight(0 ); 
         dwReturn["WBBVB"] = " ".PadRight(3 ); 
         dwReturn["WBBVG"] = " ".PadRight(3 ); 
         dwReturn["WBBVLVB"] = " ".PadRight(3 ); 
         dwReturn["WBBVLVG"] = " ".PadRight(3 ); 
         dwReturn["WBBVLSACHB"] = " ".PadRight(8 ); 
         dwReturn["WBBVLGEGEN"] = " ".PadRight(1 ); 
         dwReturn["WBBPRKUNDNR"] = " ".PadRight(8 ); 
         dwReturn["WBBGENNR"] = " ".PadRight(12 ); 
         dwReturn["WBBELOA"] = " ".PadRight(2 ); 
         dwReturn["WBBELOB"] = " ".PadRight(2 ); 
         dwReturn["WBBURAUFKRS"] = " ".PadRight(2 ); 
         dwReturn["WBBURAUFLFD"] = " ".PadRight(6 ); 
         dwReturn["WBBURAUFPOS"] = " ".PadRight(3 ); 
         dwReturn["WBBVKNPOS"] = " ".PadRight(0 ); 
         dwReturn["WBBURLAND"] = " ".PadRight(3 ); 
         dwReturn["WBBVERZKZ"] = " ".PadRight(1 ); 
         dwReturn["WBBTSTKLG"] = " ".PadRight(0 ); 
         dwReturn["WBBTANZ"] = " ".PadRight(2 ); 
         dwReturn["WBBURPOS"] = " ".PadRight(4 ); 
         dwReturn["WBBTEILPOS"] = " ".PadRight(4 ); 
         dwReturn["WBBECKZ"] = " ".PadRight(1 ); 
         dwReturn["WBBTLGAFOLGE"] = " ".PadRight(3 ); 
         dwReturn["WBBZMT"] = " ".PadRight(0 ); 
         dwReturn["WBBANZSNT"] = " ".PadRight(0 ); 
         dwReturn["WBBTLBRT"] = " ".PadRight(0 ); 
         dwReturn["WBBTLSTKLG"] = " ".PadRight(0 ); 
         dwReturn["WBBTLRICHT"] = " ".PadRight(1 ); 
         dwReturn["WBBDRKZ1"] = " ".PadRight(1 ); 
         dwReturn["WBBDRKZ2"] = " ".PadRight(1 ); 
         dwReturn["WBBEINDAT"] = " ".PadRight(0 ); 
         dwReturn["WBBWSTKLG"] = " ".PadRight(0 ); 
         dwReturn["WBBWBRT"] = " ".PadRight(0 ); 
         dwReturn["WBBWBMNRKRS"] = " ".PadRight(2 ); 
         dwReturn["WBBWBMLFDNR"] = " ".PadRight(4 ); 
         dwReturn["WBBWBMPOS"] = " ".PadRight(2 ); 
         dwReturn["WBBSCHUSS"] = " ".PadRight(0 ); 
         dwReturn["WBBWERKE"] = " ".PadRight(1 ); 
         dwReturn["WBBLIEF"] = " ".PadRight(4 ); 
         dwReturn["WBBBAHN"] = " ".PadRight(0 ); 
         dwReturn["WBBBAHNMAX"] = " ".PadRight(0 ); 
         dwReturn["WBBWLO"] = " ".PadRight(2 ); 
         dwReturn["WBBWLB"] = " ".PadRight(2 ); 
         dwReturn["WBBWLP"] = " ".PadRight(8 ); 
         dwReturn["WBBWAUFBKZ"] = " ".PadRight(1 ); 
         dwReturn["WBBKANTE"] = " ".PadRight(2 ); 
         dwReturn["WBBSOLLKZ"] = " ".PadRight(1 ); 
         dwReturn["WBBMATAB"] = " ".PadRight(1 ); 
         dwReturn["WBBWJJJJ"] = " ".PadRight(0 ); 
         dwReturn["WBBWBNR"] = " ".PadRight(0 ); 
         dwReturn["WBBFLZZUGDAT"] = " ".PadRight(0 ); 
         dwReturn["WBBISTKLGFA"] = " ".PadRight(0 ); 
         dwReturn["WBBISTKLGF"] = " ".PadRight(0 ); 
         dwReturn["WBBFRTWSKZ"] = " ".PadRight(1 ); 
         dwReturn["WBBLTPOS"] = " ".PadRight(0 ); 
         dwReturn["WBBILGFBT"] = " ".PadRight(0 ); 
         dwReturn["WBBILGRBT"] = " ".PadRight(0 ); 
         dwReturn["WBBIBRTFV"] = " ".PadRight(0 ); 
         dwReturn["WBBIBRTFB"] = " ".PadRight(0 ); 
         dwReturn["WBBFEUCHTE"] = " ".PadRight(0 ); 
         dwReturn["WBBLIEFSCH"] = " ".PadRight(10 ); 
         dwReturn["WBBKDPART"] = " ".PadRight(10 ); 
         dwReturn["WBBSCHLICHTEKZ"] = " ".PadRight(1 ); 
         dwReturn["WBBASWAKZ"] = " ".PadRight(1 ); 
         dwReturn["WBBASART"] = " ".PadRight(20 ); 
         dwReturn["WBBASVAR"] = " ".PadRight(2 ); 
         dwReturn["WBBFARBEALT"] = " ".PadRight(10 ); 
         dwReturn["WBBCOLALT"] = " ".PadRight(10 ); 
         dwReturn["WBBDESSALT"] = " ".PadRight(10 ); 
         dwReturn["WBBBESALT"] = " ".PadRight(10 ); 
         dwReturn["WBBZUSTANDA"] = " ".PadRight(4 ); 
         dwReturn["WBBMASSKZ"] = " ".PadRight(1 ); 
         dwReturn["WBBFJJJJ"] = " ".PadRight(0 ); 
         dwReturn["WBBFBNR"] = " ".PadRight(0 ); 
         dwReturn["WBBRETOURKZ"] = " ".PadRight(2 ); 
         dwReturn["WBBREAUFKRS"] = " ".PadRight(2 ); 
         dwReturn["WBBREAUFLFD"] = " ".PadRight(6 ); 
         dwReturn["WBBREAUFPOS"] = " ".PadRight(3 ); 
         dwReturn["WBBREAFOLGE"] = " ".PadRight(3 ); 
         dwReturn["WBBTPA"] = " ".PadRight(4 ); 
         dwReturn["WBBKOMMNR"] = " ".PadRight(6 ); 
         dwReturn["WBBALIEFSCH"] = " ".PadRight(8 ); 
         dwReturn["WBBPACKNR"] = " ".PadRight(4 ); 
         dwReturn["WBBPACKAUTO"] = " ".PadRight(1 ); 
         dwReturn["WBBRUEKZ"] = " ".PadRight(1 ); 
         dwReturn["WBBURLB"] = " ".PadRight(2 ); 
         dwReturn["WBBURLP"] = " ".PadRight(8 ); 
         dwReturn["WBBURAKZ"] = " ".PadRight(1 ); 
         dwReturn["WBBVERSDAT"] = " ".PadRight(0 ); 
         dwReturn["WBBVERSANDKZ"] = " ".PadRight(1 ); 
         dwReturn["WBBURLIEFSCH"] = " ".PadRight(8 ); 
         dwReturn["WBBARECHNR"] = " ".PadRight(8 ); 
         dwReturn["WBBFERTKZ"] = " ".PadRight(1 ); 
         dwReturn["WBBEGKZ"] = " ".PadRight(1 ); 
         dwReturn["WBBBEM"] = " ".PadRight(15 ); 
         dwReturn["WBBTXSCHL"] = " ".PadRight(2 ); 
         dwReturn["WBBHHK1"] = " ".PadRight(0 ); 
         dwReturn["WBBHHK2"] = " ".PadRight(0 ); 
         dwReturn["WBBHHK3"] = " ".PadRight(0 ); 
         dwReturn["WBBHHK4"] = " ".PadRight(0 ); 
         dwReturn["WBBHHK5"] = " ".PadRight(0 ); 
         dwReturn["WBBHHK6"] = " ".PadRight(0 ); 
         dwReturn["WBBHHK7"] = " ".PadRight(0 ); 
         dwReturn["WBBHHK8"] = " ".PadRight(0 ); 
         dwReturn["WBBHHK9"] = " ".PadRight(0 ); 
         dwReturn["WBBHHK10"] = " ".PadRight(0 ); 
         dwReturn["WBBHHKG"] = " ".PadRight(0 ); 
         dwReturn["WBBAHK1"] = " ".PadRight(0 ); 
         dwReturn["WBBAHK2"] = " ".PadRight(0 ); 
         dwReturn["WBBAHK3"] = " ".PadRight(0 ); 
         dwReturn["WBBAHK4"] = " ".PadRight(0 ); 
         dwReturn["WBBAHK5"] = " ".PadRight(0 ); 
         dwReturn["WBBAHK6"] = " ".PadRight(0 ); 
         dwReturn["WBBAHK7"] = " ".PadRight(0 ); 
         dwReturn["WBBAHK8"] = " ".PadRight(0 ); 
         dwReturn["WBBAHK9"] = " ".PadRight(0 ); 
         dwReturn["WBBAHK10"] = " ".PadRight(0 ); 
         dwReturn["WBBAHKG"] = " ".PadRight(0 ); 
         dwReturn["WBBABPZAB"] = " ".PadRight(0 ); 
         dwReturn["WBBABDATAB"] = " ".PadRight(0 ); 
         dwReturn["WBBNEUBEN"] = " ".PadRight(8 ); 
         dwReturn["WBBNEUDAT"] = " ".PadRight(0 ); 
         dwReturn["WBBAENDBEN"] = " ".PadRight(8 ); 
         dwReturn["WBBAENDDAT"] = " ".PadRight(0 ); 
         dwReturn["WBBAENDZL"] = " ".PadRight(0 ); 
         dwReturn["WBBWS"] = " ".PadRight(4 ); 
         dwReturn["WBBWSNO"] = " ".PadRight(0 ); 
         dwReturn["WBBREFSCHL"] = " ".PadRight(3 ); 
         dwReturn["WBBRSFSCHL"] = " ".PadRight(3 ); 
         dwReturn["WBBVEFSCHL"] = " ".PadRight(3 ); 
         dwReturn["WBBVSFSCHL"] = " ".PadRight(3 ); 
         dwReturn["WBBGRAM"] = " ".PadRight(5 ); 
         dwReturn["WBBLAEKAT"] = " ".PadRight(8 ); 
         dwReturn["WBBBRTKAT"] = " ".PadRight(4 ); 
         dwReturn["WBBFRTAUFKRS"] = " ".PadRight(2 ); 
         dwReturn["WBBFRTAUFLFD"] = " ".PadRight(6 ); 
         dwReturn["WBBFRTAUFPOS"] = " ".PadRight(3 ); 
         dwReturn["WBBSPEZKAT"] = " ".PadRight(1 ); 
         dwReturn["WBBFILLER"] = " ".PadRight(66 ); 
                    #endregion
                    break;
                case "JLT":

                    break;
                default:

                    break;
            }
            if (IsConvert)
            {
                foreach (DataColumn cm in dwInput.Table.Columns)
                {
                    if (dwInput[cm.ColumnName].ToString() == "")
                        continue;
                    if (dwReturn.Table.Columns.Contains(cm.ColumnName))
                    {
                        dwReturn[cm.ColumnName] = dwInput[cm.ColumnName];
                    }
                }
            }
            return dwReturn;
        }
        public void MapICC_WBBST(ref DataRow dwLocal, DataRow dwData)
        {
            BlindMap(ref dwLocal, dwData);
        }
        public void SaveICC_WBBST(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setResult = new DataSet();
            DataTable tbLocal = null;
            DataRow dwLocal = null;
            bool flgExist = false;
            setResult = QueryICC_WBBST(dwData);
            if (setResult.Tables.Count > 0)
            {
                tbLocal = setResult.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;
                    dwLocal = tbLocal.Rows[0];
                }
                else
                {
                    dwLocal = tbLocal.NewRow();
                }
            }
            MapICC_WBBST(ref dwLocal, dwData);

            if (!flgExist)
            {

                InsertICC_WBBST(dwLocal, ITXDBVERSION);
            }
            UpdateICC_WBBST(dwLocal);
        }
        public void InsertICC_WBBST(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "YGR":
                    or1.CommandText = "INSERT INTO ICC_WBBST(VAKBMANDANT, VAKBKOLL, VAKBART, VAKBKUNDNR, VAKBFARBE, VAKBKDARTNR, VAKBKDARTBEZ, VAKBKDFARBNR, VAKBANDRUCK, VAKBMEGEW, VAKBMENGEH, VAKBGEWVON, VAKBGEWBIS, VAKBGEWCA, VAKBGEWFKT, VAKBGEWGRP, VAKBMEGFKT, VAKBMEGGRP, VAKBAENDZL, VAKBAENDBEN, VAKBAENDDAT, VAKBNEUBEN, VAKBNEUDAT, VAKBFILLER)"
                        + " VALUES (:VAKBMANDANT, :VAKBKOLL, :VAKBART, :VAKBKUNDNR, :VAKBFARBE, '                         ', '                         ', '                             ', ' ', '   ', '   ', 0, 0, ' ', '000000000000', ' ', '000000000000', ' ', 0, '        ', '000000', '        ', '      ', '                                          ')";
                    or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                //VAFMANDANT VAFKOLL VAFART VAFFARBE VAFBEZ VAFFFARBE

            }
            
            Connect2Proxy(or1);
        }
        public DataSet QueryICC_WBBST(DataRow dwData, int option = 1)
        {
            DataSet Return;
            DataSet Result = new DataSet();
            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM ICC_WBBST WHERE  ROWNUM<2 ";
                    break;
              
                case 99:
                    or1.CommandText = "SELECT * FROM ICC_WBBST  WHERE ROWNUM<50";
                    break;
                default:
                    break;
            }
            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
                Result.Tables[0].TableName = "ICC_WBBST";
            Return = Result;
            return Return;
        }
        public void DeleteICC_WBBST(DataRow dwData, int option = 1)
        {

            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM ICC_WBBST   WHERE  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                     or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        } 
      
        public void UpdateICC_WBBST(DataRow dwData, string ITXDBVERSION = "50.24", int option = 1)
        {
            OracleCommand or1;
            DataSet Result = new DataSet();
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    #region====Command==== 
                    or1.CommandText = "UPDATE ICC_WBBST SET "
                    +"ICCDAT= :ICCDAT,"
                    +"WBBMANDANT= :WBBMANDANT,"
                    +"WBBRWKRS= :WBBRWKRS,"
                    +"WBBRWLFD= :WBBRWLFD,"
                    +"WBBPOS= :WBBPOS,"
                    +"WBBWERK= :WBBWERK,"
                    +"WBBABT= :WBBABT,"
                    +"WBBKUNDNR= :WBBKUNDNR,"
                    +"WBBSTKNR= :WBBSTKNR,"
                    +"WBBWAKZ= :WBBWAKZ,"
                    +"WBBART= :WBBART,"
                    +"WBBDESS= :WBBDESS,"
                    +"WBBCOLORIT= :WBBCOLORIT,"
                    +"WBBFARBE= :WBBFARBE,"
                    +"WBBBESCHICH= :WBBBESCHICH,"
                    +"WBBVAR= :WBBVAR,"
                    +"WBBKOLL= :WBBKOLL,"
                    +"WBBVKART= :WBBVKART,"
                    +"WBBVKFARBE= :WBBVKFARBE,"
                    +"WBBARTABW= :WBBARTABW,"
                    +"WBBARTKUNDNR= :WBBARTKUNDNR,"
                    +"WBBENTWKZ= :WBBENTWKZ,"
                    +"WBBSSTKLG= :WBBSSTKLG,"
                    +"WBBSGEW= :WBBSGEW,"
                    +"WBBSBRT= :WBBSBRT,"
                    +"WBBISTKLG= :WBBISTKLG,"
                    +"WBBIGEW= :WBBIGEW,"
                    +"WBBIBRT= :WBBIBRT,"
                    +"WBBBRGEW= :WBBBRGEW,"
                    +"WBBDM= :WBBDM,"
                    +"WBBVOL= :WBBVOL,"
                    +"WBBIGEWKZ= :WBBIGEWKZ,"
                    +"WBBIANZ= :WBBIANZ,"
                    +"WBBMABRT1= :WBBMABRT1,"
                    +"WBBMASTKLG1= :WBBMASTKLG1,"
                    +"WBBMABRT2= :WBBMABRT2,"
                    +"WBBMASTKLG2= :WBBMASTKLG2,"
                    +"WBBMABRT3= :WBBMABRT3,"
                    +"WBBMASTKLG3= :WBBMASTKLG3,"
                    +"WBBMABRT4= :WBBMABRT4,"
                    +"WBBMASTKLG4= :WBBMASTKLG4,"
                    +"WBBMABRT5= :WBBMABRT5,"
                    +"WBBMASTKLG5= :WBBMASTKLG5,"
                    +"WBBINDAT= :WBBINDAT,"
                    +"WBBINBSTMTR= :WBBINBSTMTR,"
                    +"WBBINBSTKG= :WBBINBSTKG,"
                    +"WBBIPREIS= :WBBIPREIS,"
                    +"WBBWARSCH= :WBBWARSCH,"
                    +"WBBWDATUM= :WBBWDATUM,"
                    +"WBBWSCHICHT= :WBBWSCHICHT,"
                    +"WBBWMNRKRS= :WBBWMNRKRS,"
                    +"WBBWMLFDNR= :WBBWMLFDNR,"
                    +"WBBWMPOS= :WBBWMPOS,"
                    +"WBBRE= :WBBRE,"
                    +"WBBRENETTO= :WBBRENETTO,"
                    +"WBBREVGUET= :WBBREVGUET,"
                    +"WBBRS= :WBBRS,"
                    +"WBBRSNETTO= :WBBRSNETTO,"
                    +"WBBRSVGUET= :WBBRSVGUET,"
                    +"WBBVE= :WBBVE,"
                    +"WBBVENETTO= :WBBVENETTO,"
                    +"WBBVEVGUET= :WBBVEVGUET,"
                    +"WBBVS= :WBBVS,"
                    +"WBBVSNETTO= :WBBVSNETTO,"
                    +"WBBVSVGUET= :WBBVSVGUET,"
                    +"WBBANZTEILE= :WBBANZTEILE,"
                    +"WBBVERSION= :WBBVERSION,"
                    +"WBBTAX= :WBBTAX,"
                    +"WBBZENSUR= :WBBZENSUR,"
                    +"WBBZENSURKZ= :WBBZENSURKZ,"
                    +"WBBUBRT= :WBBUBRT,"
                    +"WBBZAFOLGE= :WBBZAFOLGE,"
                    +"WBBNAFOLGE= :WBBNAFOLGE,"
                    +"WBBZLNR= :WBBZLNR,"
                    +"WBBAUFMSL= :WBBAUFMSL,"
                    +"WBBZUSAM= :WBBZUSAM,"
                    +"WBBMAART= :WBBMAART,"
                    +"WBBPACKTYP= :WBBPACKTYP,"
                    +"WBBROLLR= :WBBROLLR,"
                    +"WBBAUFMPOS= :WBBAUFMPOS,"
                    +"WBBKONFKZ= :WBBKONFKZ,"
                    +"WBBKETTELN= :WBBKETTELN,"
                    +"WBBSHSTK1= :WBBSHSTK1,"
                    +"WBBSHBRT1= :WBBSHBRT1,"
                    +"WBBSHSTKLG1= :WBBSHSTKLG1,"
                    +"WBBSHSTK2= :WBBSHSTK2,"
                    +"WBBSHBRT2= :WBBSHBRT2,"
                    +"WBBSHSTKLG2= :WBBSHSTKLG2,"
                    +"WBBSHSTK3= :WBBSHSTK3,"
                    +"WBBSHBRT3= :WBBSHBRT3,"
                    +"WBBSHSTKLG3= :WBBSHSTKLG3,"
                    +"WBBSHSTK4= :WBBSHSTK4,"
                    +"WBBSHBRT4= :WBBSHBRT4,"
                    +"WBBSHSTKLG4= :WBBSHSTKLG4,"
                    +"WBBSHSTK5= :WBBSHSTK5,"
                    +"WBBSHBRT5= :WBBSHBRT5,"
                    +"WBBSHSTKLG5= :WBBSHSTKLG5,"
                    +"WBBSTKNRK= :WBBSTKNRK,"
                    +"WBBLO= :WBBLO,"
                    +"WBBLB= :WBBLB,"
                    +"WBBKZ= :WBBKZ,"
                    +"WBBLP= :WBBLP,"
                    +"WBBAUFBKZ= :WBBAUFBKZ,"
                    +"WBBGEBNR= :WBBGEBNR,"
                    +"WBBGEBPOS= :WBBGEBPOS,"
                    +"WBBSPSTA= :WBBSPSTA,"
                    +"WBBSPGRD= :WBBSPGRD,"
                    +"WBBERLKZ= :WBBERLKZ,"
                    +"WBBAUFTYP= :WBBAUFTYP,"
                    +"WBBAUFKRS= :WBBAUFKRS,"
                    +"WBBAUFLFD= :WBBAUFLFD,"
                    +"WBBAUFPOS= :WBBAUFPOS,"
                    +"WBBTP= :WBBTP,"
                    +"WBBFOLGE= :WBBFOLGE,"
                    +"WBBAFOLGEVON= :WBBAFOLGEVON,"
                    +"WBBRAFOLGE= :WBBRAFOLGE,"
                    +"WBBMAFOLGE= :WBBMAFOLGE,"
                    +"WBBRSTKLG= :WBBRSTKLG,"
                    +"WBBRGEW= :WBBRGEW,"
                    +"WBBLGAE= :WBBLGAE,"
                    +"WBBGEWAE= :WBBGEWAE,"
                    +"WBBPOOL= :WBBPOOL,"
                    +"WBBAUTZU= :WBBAUTZU,"
                    +"WBBWDUPOS= :WBBWDUPOS,"
                    +"WBBRBENID= :WBBRBENID,"
                    +"WBBRDATB= :WBBRDATB,"
                    +"WBBRDAT= :WBBRDAT,"
                    +"WBBRBEM= :WBBRBEM,"
                    +"WBBRKUNDNR= :WBBRKUNDNR,"
                    +"WBBDPART= :WBBDPART,"
                    +"WBBDPART2= :WBBDPART2,"
                    +"WBBZUSTAND= :WBBZUSTAND,"
                    +"WBBFARBN= :WBBFARBN,"
                    +"WBBSPKZ= :WBBSPKZ,"
                    +"WBBCUKZ= :WBBCUKZ,"
                    +"WBBDISPOART= :WBBDISPOART,"
                    +"WBBDISPOVAR= :WBBDISPOVAR,"
                    +"WBBAUSFFRB= :WBBAUSFFRB,"
                    +"WBBAUSFGRI= :WBBAUSFGRI,"
                    +"WBBAUSFQUAL= :WBBAUSFQUAL,"
                    +"WBBQUALST= :WBBQUALST,"
                    +"WBBQPKT= :WBBQPKT,"
                    +"WBBQPKTH= :WBBQPKTH,"
                    +"WBBQPKTL= :WBBQPKTL,"
                    +"WBBQPKTLH= :WBBQPKTLH,"
                    +"WBBVB= :WBBVB,"
                    +"WBBVG= :WBBVG,"
                    +"WBBVLVB= :WBBVLVB,"
                    +"WBBVLVG= :WBBVLVG,"
                    +"WBBVLSACHB= :WBBVLSACHB,"
                    +"WBBVLGEGEN= :WBBVLGEGEN,"
                    +"WBBPRKUNDNR= :WBBPRKUNDNR,"
                    +"WBBGENNR= :WBBGENNR,"
                    +"WBBELOA= :WBBELOA,"
                    +"WBBELOB= :WBBELOB,"
                    +"WBBURAUFKRS= :WBBURAUFKRS,"
                    +"WBBURAUFLFD= :WBBURAUFLFD,"
                    +"WBBURAUFPOS= :WBBURAUFPOS,"
                    +"WBBVKNPOS= :WBBVKNPOS,"
                    +"WBBURLAND= :WBBURLAND,"
                    +"WBBVERZKZ= :WBBVERZKZ,"
                    +"WBBTSTKLG= :WBBTSTKLG,"
                    +"WBBTANZ= :WBBTANZ,"
                    +"WBBURPOS= :WBBURPOS,"
                    +"WBBTEILPOS= :WBBTEILPOS,"
                    +"WBBECKZ= :WBBECKZ,"
                    +"WBBTLGAFOLGE= :WBBTLGAFOLGE,"
                    +"WBBZMT= :WBBZMT,"
                    +"WBBANZSNT= :WBBANZSNT,"
                    +"WBBTLBRT= :WBBTLBRT,"
                    +"WBBTLSTKLG= :WBBTLSTKLG,"
                    +"WBBTLRICHT= :WBBTLRICHT,"
                    +"WBBDRKZ1= :WBBDRKZ1,"
                    +"WBBDRKZ2= :WBBDRKZ2,"
                    +"WBBEINDAT= :WBBEINDAT,"
                    +"WBBWSTKLG= :WBBWSTKLG,"
                    +"WBBWBRT= :WBBWBRT,"
                    +"WBBWBMNRKRS= :WBBWBMNRKRS,"
                    +"WBBWBMLFDNR= :WBBWBMLFDNR,"
                    +"WBBWBMPOS= :WBBWBMPOS,"
                    +"WBBSCHUSS= :WBBSCHUSS,"
                    +"WBBWERKE= :WBBWERKE,"
                    +"WBBLIEF= :WBBLIEF,"
                    +"WBBBAHN= :WBBBAHN,"
                    +"WBBBAHNMAX= :WBBBAHNMAX,"
                    +"WBBWLO= :WBBWLO,"
                    +"WBBWLB= :WBBWLB,"
                    +"WBBWLP= :WBBWLP,"
                    +"WBBWAUFBKZ= :WBBWAUFBKZ,"
                    +"WBBKANTE= :WBBKANTE,"
                    +"WBBSOLLKZ= :WBBSOLLKZ,"
                    +"WBBMATAB= :WBBMATAB,"
                    +"WBBWJJJJ= :WBBWJJJJ,"
                    +"WBBWBNR= :WBBWBNR,"
                    +"WBBFLZZUGDAT= :WBBFLZZUGDAT,"
                    +"WBBISTKLGFA= :WBBISTKLGFA,"
                    +"WBBISTKLGF= :WBBISTKLGF,"
                    +"WBBFRTWSKZ= :WBBFRTWSKZ,"
                    +"WBBLTPOS= :WBBLTPOS,"
                    +"WBBILGFBT= :WBBILGFBT,"
                    +"WBBILGRBT= :WBBILGRBT,"
                    +"WBBIBRTFV= :WBBIBRTFV,"
                    +"WBBIBRTFB= :WBBIBRTFB,"
                    +"WBBFEUCHTE= :WBBFEUCHTE,"
                    +"WBBLIEFSCH= :WBBLIEFSCH,"
                    +"WBBKDPART= :WBBKDPART,"
                    +"WBBSCHLICHTEKZ= :WBBSCHLICHTEKZ,"
                    +"WBBASWAKZ= :WBBASWAKZ,"
                    +"WBBASART= :WBBASART,"
                    +"WBBASVAR= :WBBASVAR,"
                    +"WBBFARBEALT= :WBBFARBEALT,"
                    +"WBBCOLALT= :WBBCOLALT,"
                    +"WBBDESSALT= :WBBDESSALT,"
                    +"WBBBESALT= :WBBBESALT,"
                    +"WBBZUSTANDA= :WBBZUSTANDA,"
                    +"WBBMASSKZ= :WBBMASSKZ,"
                    +"WBBFJJJJ= :WBBFJJJJ,"
                    +"WBBFBNR= :WBBFBNR,"
                    +"WBBRETOURKZ= :WBBRETOURKZ,"
                    +"WBBREAUFKRS= :WBBREAUFKRS,"
                    +"WBBREAUFLFD= :WBBREAUFLFD,"
                    +"WBBREAUFPOS= :WBBREAUFPOS,"
                    +"WBBREAFOLGE= :WBBREAFOLGE,"
                    +"WBBTPA= :WBBTPA,"
                    +"WBBKOMMNR= :WBBKOMMNR,"
                    +"WBBALIEFSCH= :WBBALIEFSCH,"
                    +"WBBPACKNR= :WBBPACKNR,"
                    +"WBBPACKAUTO= :WBBPACKAUTO,"
                    +"WBBRUEKZ= :WBBRUEKZ,"
                    +"WBBURLB= :WBBURLB,"
                    +"WBBURLP= :WBBURLP,"
                    +"WBBURAKZ= :WBBURAKZ,"
                    +"WBBVERSDAT= :WBBVERSDAT,"
                    +"WBBVERSANDKZ= :WBBVERSANDKZ,"
                    +"WBBURLIEFSCH= :WBBURLIEFSCH,"
                    +"WBBARECHNR= :WBBARECHNR,"
                    +"WBBFERTKZ= :WBBFERTKZ,"
                    +"WBBEGKZ= :WBBEGKZ,"
                    +"WBBBEM= :WBBBEM,"
                    +"WBBTXSCHL= :WBBTXSCHL,"
                    +"WBBHHK1= :WBBHHK1,"
                    +"WBBHHK2= :WBBHHK2,"
                    +"WBBHHK3= :WBBHHK3,"
                    +"WBBHHK4= :WBBHHK4,"
                    +"WBBHHK5= :WBBHHK5,"
                    +"WBBHHK6= :WBBHHK6,"
                    +"WBBHHK7= :WBBHHK7,"
                    +"WBBHHK8= :WBBHHK8,"
                    +"WBBHHK9= :WBBHHK9,"
                    +"WBBHHK10= :WBBHHK10,"
                    +"WBBHHKG= :WBBHHKG,"
                    +"WBBAHK1= :WBBAHK1,"
                    +"WBBAHK2= :WBBAHK2,"
                    +"WBBAHK3= :WBBAHK3,"
                    +"WBBAHK4= :WBBAHK4,"
                    +"WBBAHK5= :WBBAHK5,"
                    +"WBBAHK6= :WBBAHK6,"
                    +"WBBAHK7= :WBBAHK7,"
                    +"WBBAHK8= :WBBAHK8,"
                    +"WBBAHK9= :WBBAHK9,"
                    +"WBBAHK10= :WBBAHK10,"
                    +"WBBAHKG= :WBBAHKG,"
                    +"WBBABPZAB= :WBBABPZAB,"
                    +"WBBABDATAB= :WBBABDATAB,"
                    +"WBBNEUBEN= :WBBNEUBEN,"
                    +"WBBNEUDAT= :WBBNEUDAT,"
                    +"WBBAENDBEN= :WBBAENDBEN,"
                    +"WBBAENDDAT= :WBBAENDDAT,"
                    +"WBBAENDZL= :WBBAENDZL,"
                    +"WBBWS= :WBBWS,"
                    +"WBBWSNO= :WBBWSNO,"
                    +"WBBREFSCHL= :WBBREFSCHL,"
                    +"WBBRSFSCHL= :WBBRSFSCHL,"
                    +"WBBVEFSCHL= :WBBVEFSCHL,"
                    +"WBBVSFSCHL= :WBBVSFSCHL,"
                    +"WBBGRAM= :WBBGRAM,"
                    +"WBBLAEKAT= :WBBLAEKAT,"
                    +"WBBBRTKAT= :WBBBRTKAT,"
                    +"WBBFRTAUFKRS= :WBBFRTAUFKRS,"
                    +"WBBFRTAUFLFD= :WBBFRTAUFLFD,"
                    +"WBBFRTAUFPOS= :WBBFRTAUFPOS,"
                    +"WBBSPEZKAT= :WBBSPEZKAT,"
                    +"WBBFILLER= :WBBFILLER,"
                        + " WHERE  "
                        + "  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                    #endregion

                    #region====Parameters====
          or1.Parameters.Add("ICCDAT", OracleType.NVarChar).Value = dwData["ICCDAT"].ToString(); 
          or1.Parameters.Add("WBBMANDANT", OracleType.NVarChar).Value = dwData["WBBMANDANT"].ToString(); 
          or1.Parameters.Add("WBBRWKRS", OracleType.NVarChar).Value = dwData["WBBRWKRS"].ToString(); 
          or1.Parameters.Add("WBBRWLFD", OracleType.NVarChar).Value = dwData["WBBRWLFD"].ToString(); 
          or1.Parameters.Add("WBBPOS", OracleType.NVarChar).Value = dwData["WBBPOS"].ToString(); 
          or1.Parameters.Add("WBBWERK", OracleType.NVarChar).Value = dwData["WBBWERK"].ToString(); 
          or1.Parameters.Add("WBBABT", OracleType.NVarChar).Value = dwData["WBBABT"].ToString(); 
          or1.Parameters.Add("WBBKUNDNR", OracleType.NVarChar).Value = dwData["WBBKUNDNR"].ToString(); 
          or1.Parameters.Add("WBBSTKNR", OracleType.NVarChar).Value = dwData["WBBSTKNR"].ToString(); 
          or1.Parameters.Add("WBBWAKZ", OracleType.NVarChar).Value = dwData["WBBWAKZ"].ToString(); 
          or1.Parameters.Add("WBBART", OracleType.NVarChar).Value = dwData["WBBART"].ToString(); 
          or1.Parameters.Add("WBBDESS", OracleType.NVarChar).Value = dwData["WBBDESS"].ToString(); 
          or1.Parameters.Add("WBBCOLORIT", OracleType.NVarChar).Value = dwData["WBBCOLORIT"].ToString(); 
          or1.Parameters.Add("WBBFARBE", OracleType.NVarChar).Value = dwData["WBBFARBE"].ToString(); 
          or1.Parameters.Add("WBBBESCHICH", OracleType.NVarChar).Value = dwData["WBBBESCHICH"].ToString(); 
          or1.Parameters.Add("WBBVAR", OracleType.NVarChar).Value = dwData["WBBVAR"].ToString(); 
          or1.Parameters.Add("WBBKOLL", OracleType.NVarChar).Value = dwData["WBBKOLL"].ToString(); 
          or1.Parameters.Add("WBBVKART", OracleType.NVarChar).Value = dwData["WBBVKART"].ToString(); 
          or1.Parameters.Add("WBBVKFARBE", OracleType.NVarChar).Value = dwData["WBBVKFARBE"].ToString(); 
          or1.Parameters.Add("WBBARTABW", OracleType.NVarChar).Value = dwData["WBBARTABW"].ToString(); 
          or1.Parameters.Add("WBBARTKUNDNR", OracleType.NVarChar).Value = dwData["WBBARTKUNDNR"].ToString(); 
          or1.Parameters.Add("WBBENTWKZ", OracleType.NVarChar).Value = dwData["WBBENTWKZ"].ToString(); 
          or1.Parameters.Add("WBBSSTKLG", OracleType.NVarChar).Value = dwData["WBBSSTKLG"].ToString(); 
          or1.Parameters.Add("WBBSGEW", OracleType.NVarChar).Value = dwData["WBBSGEW"].ToString(); 
          or1.Parameters.Add("WBBSBRT", OracleType.NVarChar).Value = dwData["WBBSBRT"].ToString(); 
          or1.Parameters.Add("WBBISTKLG", OracleType.NVarChar).Value = dwData["WBBISTKLG"].ToString(); 
          or1.Parameters.Add("WBBIGEW", OracleType.NVarChar).Value = dwData["WBBIGEW"].ToString(); 
          or1.Parameters.Add("WBBIBRT", OracleType.NVarChar).Value = dwData["WBBIBRT"].ToString(); 
          or1.Parameters.Add("WBBBRGEW", OracleType.NVarChar).Value = dwData["WBBBRGEW"].ToString(); 
          or1.Parameters.Add("WBBDM", OracleType.NVarChar).Value = dwData["WBBDM"].ToString(); 
          or1.Parameters.Add("WBBVOL", OracleType.NVarChar).Value = dwData["WBBVOL"].ToString(); 
          or1.Parameters.Add("WBBIGEWKZ", OracleType.NVarChar).Value = dwData["WBBIGEWKZ"].ToString(); 
          or1.Parameters.Add("WBBIANZ", OracleType.NVarChar).Value = dwData["WBBIANZ"].ToString(); 
          or1.Parameters.Add("WBBMABRT1", OracleType.NVarChar).Value = dwData["WBBMABRT1"].ToString(); 
          or1.Parameters.Add("WBBMASTKLG1", OracleType.NVarChar).Value = dwData["WBBMASTKLG1"].ToString(); 
          or1.Parameters.Add("WBBMABRT2", OracleType.NVarChar).Value = dwData["WBBMABRT2"].ToString(); 
          or1.Parameters.Add("WBBMASTKLG2", OracleType.NVarChar).Value = dwData["WBBMASTKLG2"].ToString(); 
          or1.Parameters.Add("WBBMABRT3", OracleType.NVarChar).Value = dwData["WBBMABRT3"].ToString(); 
          or1.Parameters.Add("WBBMASTKLG3", OracleType.NVarChar).Value = dwData["WBBMASTKLG3"].ToString(); 
          or1.Parameters.Add("WBBMABRT4", OracleType.NVarChar).Value = dwData["WBBMABRT4"].ToString(); 
          or1.Parameters.Add("WBBMASTKLG4", OracleType.NVarChar).Value = dwData["WBBMASTKLG4"].ToString(); 
          or1.Parameters.Add("WBBMABRT5", OracleType.NVarChar).Value = dwData["WBBMABRT5"].ToString(); 
          or1.Parameters.Add("WBBMASTKLG5", OracleType.NVarChar).Value = dwData["WBBMASTKLG5"].ToString(); 
          or1.Parameters.Add("WBBINDAT", OracleType.NVarChar).Value = dwData["WBBINDAT"].ToString(); 
          or1.Parameters.Add("WBBINBSTMTR", OracleType.NVarChar).Value = dwData["WBBINBSTMTR"].ToString(); 
          or1.Parameters.Add("WBBINBSTKG", OracleType.NVarChar).Value = dwData["WBBINBSTKG"].ToString(); 
          or1.Parameters.Add("WBBIPREIS", OracleType.NVarChar).Value = dwData["WBBIPREIS"].ToString(); 
          or1.Parameters.Add("WBBWARSCH", OracleType.NVarChar).Value = dwData["WBBWARSCH"].ToString(); 
          or1.Parameters.Add("WBBWDATUM", OracleType.NVarChar).Value = dwData["WBBWDATUM"].ToString(); 
          or1.Parameters.Add("WBBWSCHICHT", OracleType.NVarChar).Value = dwData["WBBWSCHICHT"].ToString(); 
          or1.Parameters.Add("WBBWMNRKRS", OracleType.NVarChar).Value = dwData["WBBWMNRKRS"].ToString(); 
          or1.Parameters.Add("WBBWMLFDNR", OracleType.NVarChar).Value = dwData["WBBWMLFDNR"].ToString(); 
          or1.Parameters.Add("WBBWMPOS", OracleType.NVarChar).Value = dwData["WBBWMPOS"].ToString(); 
          or1.Parameters.Add("WBBRE", OracleType.NVarChar).Value = dwData["WBBRE"].ToString(); 
          or1.Parameters.Add("WBBRENETTO", OracleType.NVarChar).Value = dwData["WBBRENETTO"].ToString(); 
          or1.Parameters.Add("WBBREVGUET", OracleType.NVarChar).Value = dwData["WBBREVGUET"].ToString(); 
          or1.Parameters.Add("WBBRS", OracleType.NVarChar).Value = dwData["WBBRS"].ToString(); 
          or1.Parameters.Add("WBBRSNETTO", OracleType.NVarChar).Value = dwData["WBBRSNETTO"].ToString(); 
          or1.Parameters.Add("WBBRSVGUET", OracleType.NVarChar).Value = dwData["WBBRSVGUET"].ToString(); 
          or1.Parameters.Add("WBBVE", OracleType.NVarChar).Value = dwData["WBBVE"].ToString(); 
          or1.Parameters.Add("WBBVENETTO", OracleType.NVarChar).Value = dwData["WBBVENETTO"].ToString(); 
          or1.Parameters.Add("WBBVEVGUET", OracleType.NVarChar).Value = dwData["WBBVEVGUET"].ToString(); 
          or1.Parameters.Add("WBBVS", OracleType.NVarChar).Value = dwData["WBBVS"].ToString(); 
          or1.Parameters.Add("WBBVSNETTO", OracleType.NVarChar).Value = dwData["WBBVSNETTO"].ToString(); 
          or1.Parameters.Add("WBBVSVGUET", OracleType.NVarChar).Value = dwData["WBBVSVGUET"].ToString(); 
          or1.Parameters.Add("WBBANZTEILE", OracleType.NVarChar).Value = dwData["WBBANZTEILE"].ToString(); 
          or1.Parameters.Add("WBBVERSION", OracleType.NVarChar).Value = dwData["WBBVERSION"].ToString(); 
          or1.Parameters.Add("WBBTAX", OracleType.NVarChar).Value = dwData["WBBTAX"].ToString(); 
          or1.Parameters.Add("WBBZENSUR", OracleType.NVarChar).Value = dwData["WBBZENSUR"].ToString(); 
          or1.Parameters.Add("WBBZENSURKZ", OracleType.NVarChar).Value = dwData["WBBZENSURKZ"].ToString(); 
          or1.Parameters.Add("WBBUBRT", OracleType.NVarChar).Value = dwData["WBBUBRT"].ToString(); 
          or1.Parameters.Add("WBBZAFOLGE", OracleType.NVarChar).Value = dwData["WBBZAFOLGE"].ToString(); 
          or1.Parameters.Add("WBBNAFOLGE", OracleType.NVarChar).Value = dwData["WBBNAFOLGE"].ToString(); 
          or1.Parameters.Add("WBBZLNR", OracleType.NVarChar).Value = dwData["WBBZLNR"].ToString(); 
          or1.Parameters.Add("WBBAUFMSL", OracleType.NVarChar).Value = dwData["WBBAUFMSL"].ToString(); 
          or1.Parameters.Add("WBBZUSAM", OracleType.NVarChar).Value = dwData["WBBZUSAM"].ToString(); 
          or1.Parameters.Add("WBBMAART", OracleType.NVarChar).Value = dwData["WBBMAART"].ToString(); 
          or1.Parameters.Add("WBBPACKTYP", OracleType.NVarChar).Value = dwData["WBBPACKTYP"].ToString(); 
          or1.Parameters.Add("WBBROLLR", OracleType.NVarChar).Value = dwData["WBBROLLR"].ToString(); 
          or1.Parameters.Add("WBBAUFMPOS", OracleType.NVarChar).Value = dwData["WBBAUFMPOS"].ToString(); 
          or1.Parameters.Add("WBBKONFKZ", OracleType.NVarChar).Value = dwData["WBBKONFKZ"].ToString(); 
          or1.Parameters.Add("WBBKETTELN", OracleType.NVarChar).Value = dwData["WBBKETTELN"].ToString(); 
          or1.Parameters.Add("WBBSHSTK1", OracleType.NVarChar).Value = dwData["WBBSHSTK1"].ToString(); 
          or1.Parameters.Add("WBBSHBRT1", OracleType.NVarChar).Value = dwData["WBBSHBRT1"].ToString(); 
          or1.Parameters.Add("WBBSHSTKLG1", OracleType.NVarChar).Value = dwData["WBBSHSTKLG1"].ToString(); 
          or1.Parameters.Add("WBBSHSTK2", OracleType.NVarChar).Value = dwData["WBBSHSTK2"].ToString(); 
          or1.Parameters.Add("WBBSHBRT2", OracleType.NVarChar).Value = dwData["WBBSHBRT2"].ToString(); 
          or1.Parameters.Add("WBBSHSTKLG2", OracleType.NVarChar).Value = dwData["WBBSHSTKLG2"].ToString(); 
          or1.Parameters.Add("WBBSHSTK3", OracleType.NVarChar).Value = dwData["WBBSHSTK3"].ToString(); 
          or1.Parameters.Add("WBBSHBRT3", OracleType.NVarChar).Value = dwData["WBBSHBRT3"].ToString(); 
          or1.Parameters.Add("WBBSHSTKLG3", OracleType.NVarChar).Value = dwData["WBBSHSTKLG3"].ToString(); 
          or1.Parameters.Add("WBBSHSTK4", OracleType.NVarChar).Value = dwData["WBBSHSTK4"].ToString(); 
          or1.Parameters.Add("WBBSHBRT4", OracleType.NVarChar).Value = dwData["WBBSHBRT4"].ToString(); 
          or1.Parameters.Add("WBBSHSTKLG4", OracleType.NVarChar).Value = dwData["WBBSHSTKLG4"].ToString(); 
          or1.Parameters.Add("WBBSHSTK5", OracleType.NVarChar).Value = dwData["WBBSHSTK5"].ToString(); 
          or1.Parameters.Add("WBBSHBRT5", OracleType.NVarChar).Value = dwData["WBBSHBRT5"].ToString(); 
          or1.Parameters.Add("WBBSHSTKLG5", OracleType.NVarChar).Value = dwData["WBBSHSTKLG5"].ToString(); 
          or1.Parameters.Add("WBBSTKNRK", OracleType.NVarChar).Value = dwData["WBBSTKNRK"].ToString(); 
          or1.Parameters.Add("WBBLO", OracleType.NVarChar).Value = dwData["WBBLO"].ToString(); 
          or1.Parameters.Add("WBBLB", OracleType.NVarChar).Value = dwData["WBBLB"].ToString(); 
          or1.Parameters.Add("WBBKZ", OracleType.NVarChar).Value = dwData["WBBKZ"].ToString(); 
          or1.Parameters.Add("WBBLP", OracleType.NVarChar).Value = dwData["WBBLP"].ToString(); 
          or1.Parameters.Add("WBBAUFBKZ", OracleType.NVarChar).Value = dwData["WBBAUFBKZ"].ToString(); 
          or1.Parameters.Add("WBBGEBNR", OracleType.NVarChar).Value = dwData["WBBGEBNR"].ToString(); 
          or1.Parameters.Add("WBBGEBPOS", OracleType.NVarChar).Value = dwData["WBBGEBPOS"].ToString(); 
          or1.Parameters.Add("WBBSPSTA", OracleType.NVarChar).Value = dwData["WBBSPSTA"].ToString(); 
          or1.Parameters.Add("WBBSPGRD", OracleType.NVarChar).Value = dwData["WBBSPGRD"].ToString(); 
          or1.Parameters.Add("WBBERLKZ", OracleType.NVarChar).Value = dwData["WBBERLKZ"].ToString(); 
          or1.Parameters.Add("WBBAUFTYP", OracleType.NVarChar).Value = dwData["WBBAUFTYP"].ToString(); 
          or1.Parameters.Add("WBBAUFKRS", OracleType.NVarChar).Value = dwData["WBBAUFKRS"].ToString(); 
          or1.Parameters.Add("WBBAUFLFD", OracleType.NVarChar).Value = dwData["WBBAUFLFD"].ToString(); 
          or1.Parameters.Add("WBBAUFPOS", OracleType.NVarChar).Value = dwData["WBBAUFPOS"].ToString(); 
          or1.Parameters.Add("WBBTP", OracleType.NVarChar).Value = dwData["WBBTP"].ToString(); 
          or1.Parameters.Add("WBBFOLGE", OracleType.NVarChar).Value = dwData["WBBFOLGE"].ToString(); 
          or1.Parameters.Add("WBBAFOLGEVON", OracleType.NVarChar).Value = dwData["WBBAFOLGEVON"].ToString(); 
          or1.Parameters.Add("WBBRAFOLGE", OracleType.NVarChar).Value = dwData["WBBRAFOLGE"].ToString(); 
          or1.Parameters.Add("WBBMAFOLGE", OracleType.NVarChar).Value = dwData["WBBMAFOLGE"].ToString(); 
          or1.Parameters.Add("WBBRSTKLG", OracleType.NVarChar).Value = dwData["WBBRSTKLG"].ToString(); 
          or1.Parameters.Add("WBBRGEW", OracleType.NVarChar).Value = dwData["WBBRGEW"].ToString(); 
          or1.Parameters.Add("WBBLGAE", OracleType.NVarChar).Value = dwData["WBBLGAE"].ToString(); 
          or1.Parameters.Add("WBBGEWAE", OracleType.NVarChar).Value = dwData["WBBGEWAE"].ToString(); 
          or1.Parameters.Add("WBBPOOL", OracleType.NVarChar).Value = dwData["WBBPOOL"].ToString(); 
          or1.Parameters.Add("WBBAUTZU", OracleType.NVarChar).Value = dwData["WBBAUTZU"].ToString(); 
          or1.Parameters.Add("WBBWDUPOS", OracleType.NVarChar).Value = dwData["WBBWDUPOS"].ToString(); 
          or1.Parameters.Add("WBBRBENID", OracleType.NVarChar).Value = dwData["WBBRBENID"].ToString(); 
          or1.Parameters.Add("WBBRDATB", OracleType.NVarChar).Value = dwData["WBBRDATB"].ToString(); 
          or1.Parameters.Add("WBBRDAT", OracleType.NVarChar).Value = dwData["WBBRDAT"].ToString(); 
          or1.Parameters.Add("WBBRBEM", OracleType.NVarChar).Value = dwData["WBBRBEM"].ToString(); 
          or1.Parameters.Add("WBBRKUNDNR", OracleType.NVarChar).Value = dwData["WBBRKUNDNR"].ToString(); 
          or1.Parameters.Add("WBBDPART", OracleType.NVarChar).Value = dwData["WBBDPART"].ToString(); 
          or1.Parameters.Add("WBBDPART2", OracleType.NVarChar).Value = dwData["WBBDPART2"].ToString(); 
          or1.Parameters.Add("WBBZUSTAND", OracleType.NVarChar).Value = dwData["WBBZUSTAND"].ToString(); 
          or1.Parameters.Add("WBBFARBN", OracleType.NVarChar).Value = dwData["WBBFARBN"].ToString(); 
          or1.Parameters.Add("WBBSPKZ", OracleType.NVarChar).Value = dwData["WBBSPKZ"].ToString(); 
          or1.Parameters.Add("WBBCUKZ", OracleType.NVarChar).Value = dwData["WBBCUKZ"].ToString(); 
          or1.Parameters.Add("WBBDISPOART", OracleType.NVarChar).Value = dwData["WBBDISPOART"].ToString(); 
          or1.Parameters.Add("WBBDISPOVAR", OracleType.NVarChar).Value = dwData["WBBDISPOVAR"].ToString(); 
          or1.Parameters.Add("WBBAUSFFRB", OracleType.NVarChar).Value = dwData["WBBAUSFFRB"].ToString(); 
          or1.Parameters.Add("WBBAUSFGRI", OracleType.NVarChar).Value = dwData["WBBAUSFGRI"].ToString(); 
          or1.Parameters.Add("WBBAUSFQUAL", OracleType.NVarChar).Value = dwData["WBBAUSFQUAL"].ToString(); 
          or1.Parameters.Add("WBBQUALST", OracleType.NVarChar).Value = dwData["WBBQUALST"].ToString(); 
          or1.Parameters.Add("WBBQPKT", OracleType.NVarChar).Value = dwData["WBBQPKT"].ToString(); 
          or1.Parameters.Add("WBBQPKTH", OracleType.NVarChar).Value = dwData["WBBQPKTH"].ToString(); 
          or1.Parameters.Add("WBBQPKTL", OracleType.NVarChar).Value = dwData["WBBQPKTL"].ToString(); 
          or1.Parameters.Add("WBBQPKTLH", OracleType.NVarChar).Value = dwData["WBBQPKTLH"].ToString(); 
          or1.Parameters.Add("WBBVB", OracleType.NVarChar).Value = dwData["WBBVB"].ToString(); 
          or1.Parameters.Add("WBBVG", OracleType.NVarChar).Value = dwData["WBBVG"].ToString(); 
          or1.Parameters.Add("WBBVLVB", OracleType.NVarChar).Value = dwData["WBBVLVB"].ToString(); 
          or1.Parameters.Add("WBBVLVG", OracleType.NVarChar).Value = dwData["WBBVLVG"].ToString(); 
          or1.Parameters.Add("WBBVLSACHB", OracleType.NVarChar).Value = dwData["WBBVLSACHB"].ToString(); 
          or1.Parameters.Add("WBBVLGEGEN", OracleType.NVarChar).Value = dwData["WBBVLGEGEN"].ToString(); 
          or1.Parameters.Add("WBBPRKUNDNR", OracleType.NVarChar).Value = dwData["WBBPRKUNDNR"].ToString(); 
          or1.Parameters.Add("WBBGENNR", OracleType.NVarChar).Value = dwData["WBBGENNR"].ToString(); 
          or1.Parameters.Add("WBBELOA", OracleType.NVarChar).Value = dwData["WBBELOA"].ToString(); 
          or1.Parameters.Add("WBBELOB", OracleType.NVarChar).Value = dwData["WBBELOB"].ToString(); 
          or1.Parameters.Add("WBBURAUFKRS", OracleType.NVarChar).Value = dwData["WBBURAUFKRS"].ToString(); 
          or1.Parameters.Add("WBBURAUFLFD", OracleType.NVarChar).Value = dwData["WBBURAUFLFD"].ToString(); 
          or1.Parameters.Add("WBBURAUFPOS", OracleType.NVarChar).Value = dwData["WBBURAUFPOS"].ToString(); 
          or1.Parameters.Add("WBBVKNPOS", OracleType.NVarChar).Value = dwData["WBBVKNPOS"].ToString(); 
          or1.Parameters.Add("WBBURLAND", OracleType.NVarChar).Value = dwData["WBBURLAND"].ToString(); 
          or1.Parameters.Add("WBBVERZKZ", OracleType.NVarChar).Value = dwData["WBBVERZKZ"].ToString(); 
          or1.Parameters.Add("WBBTSTKLG", OracleType.NVarChar).Value = dwData["WBBTSTKLG"].ToString(); 
          or1.Parameters.Add("WBBTANZ", OracleType.NVarChar).Value = dwData["WBBTANZ"].ToString(); 
          or1.Parameters.Add("WBBURPOS", OracleType.NVarChar).Value = dwData["WBBURPOS"].ToString(); 
          or1.Parameters.Add("WBBTEILPOS", OracleType.NVarChar).Value = dwData["WBBTEILPOS"].ToString(); 
          or1.Parameters.Add("WBBECKZ", OracleType.NVarChar).Value = dwData["WBBECKZ"].ToString(); 
          or1.Parameters.Add("WBBTLGAFOLGE", OracleType.NVarChar).Value = dwData["WBBTLGAFOLGE"].ToString(); 
          or1.Parameters.Add("WBBZMT", OracleType.NVarChar).Value = dwData["WBBZMT"].ToString(); 
          or1.Parameters.Add("WBBANZSNT", OracleType.NVarChar).Value = dwData["WBBANZSNT"].ToString(); 
          or1.Parameters.Add("WBBTLBRT", OracleType.NVarChar).Value = dwData["WBBTLBRT"].ToString(); 
          or1.Parameters.Add("WBBTLSTKLG", OracleType.NVarChar).Value = dwData["WBBTLSTKLG"].ToString(); 
          or1.Parameters.Add("WBBTLRICHT", OracleType.NVarChar).Value = dwData["WBBTLRICHT"].ToString(); 
          or1.Parameters.Add("WBBDRKZ1", OracleType.NVarChar).Value = dwData["WBBDRKZ1"].ToString(); 
          or1.Parameters.Add("WBBDRKZ2", OracleType.NVarChar).Value = dwData["WBBDRKZ2"].ToString(); 
          or1.Parameters.Add("WBBEINDAT", OracleType.NVarChar).Value = dwData["WBBEINDAT"].ToString(); 
          or1.Parameters.Add("WBBWSTKLG", OracleType.NVarChar).Value = dwData["WBBWSTKLG"].ToString(); 
          or1.Parameters.Add("WBBWBRT", OracleType.NVarChar).Value = dwData["WBBWBRT"].ToString(); 
          or1.Parameters.Add("WBBWBMNRKRS", OracleType.NVarChar).Value = dwData["WBBWBMNRKRS"].ToString(); 
          or1.Parameters.Add("WBBWBMLFDNR", OracleType.NVarChar).Value = dwData["WBBWBMLFDNR"].ToString(); 
          or1.Parameters.Add("WBBWBMPOS", OracleType.NVarChar).Value = dwData["WBBWBMPOS"].ToString(); 
          or1.Parameters.Add("WBBSCHUSS", OracleType.NVarChar).Value = dwData["WBBSCHUSS"].ToString(); 
          or1.Parameters.Add("WBBWERKE", OracleType.NVarChar).Value = dwData["WBBWERKE"].ToString(); 
          or1.Parameters.Add("WBBLIEF", OracleType.NVarChar).Value = dwData["WBBLIEF"].ToString(); 
          or1.Parameters.Add("WBBBAHN", OracleType.NVarChar).Value = dwData["WBBBAHN"].ToString(); 
          or1.Parameters.Add("WBBBAHNMAX", OracleType.NVarChar).Value = dwData["WBBBAHNMAX"].ToString(); 
          or1.Parameters.Add("WBBWLO", OracleType.NVarChar).Value = dwData["WBBWLO"].ToString(); 
          or1.Parameters.Add("WBBWLB", OracleType.NVarChar).Value = dwData["WBBWLB"].ToString(); 
          or1.Parameters.Add("WBBWLP", OracleType.NVarChar).Value = dwData["WBBWLP"].ToString(); 
          or1.Parameters.Add("WBBWAUFBKZ", OracleType.NVarChar).Value = dwData["WBBWAUFBKZ"].ToString(); 
          or1.Parameters.Add("WBBKANTE", OracleType.NVarChar).Value = dwData["WBBKANTE"].ToString(); 
          or1.Parameters.Add("WBBSOLLKZ", OracleType.NVarChar).Value = dwData["WBBSOLLKZ"].ToString(); 
          or1.Parameters.Add("WBBMATAB", OracleType.NVarChar).Value = dwData["WBBMATAB"].ToString(); 
          or1.Parameters.Add("WBBWJJJJ", OracleType.NVarChar).Value = dwData["WBBWJJJJ"].ToString(); 
          or1.Parameters.Add("WBBWBNR", OracleType.NVarChar).Value = dwData["WBBWBNR"].ToString(); 
          or1.Parameters.Add("WBBFLZZUGDAT", OracleType.NVarChar).Value = dwData["WBBFLZZUGDAT"].ToString(); 
          or1.Parameters.Add("WBBISTKLGFA", OracleType.NVarChar).Value = dwData["WBBISTKLGFA"].ToString(); 
          or1.Parameters.Add("WBBISTKLGF", OracleType.NVarChar).Value = dwData["WBBISTKLGF"].ToString(); 
          or1.Parameters.Add("WBBFRTWSKZ", OracleType.NVarChar).Value = dwData["WBBFRTWSKZ"].ToString(); 
          or1.Parameters.Add("WBBLTPOS", OracleType.NVarChar).Value = dwData["WBBLTPOS"].ToString(); 
          or1.Parameters.Add("WBBILGFBT", OracleType.NVarChar).Value = dwData["WBBILGFBT"].ToString(); 
          or1.Parameters.Add("WBBILGRBT", OracleType.NVarChar).Value = dwData["WBBILGRBT"].ToString(); 
          or1.Parameters.Add("WBBIBRTFV", OracleType.NVarChar).Value = dwData["WBBIBRTFV"].ToString(); 
          or1.Parameters.Add("WBBIBRTFB", OracleType.NVarChar).Value = dwData["WBBIBRTFB"].ToString(); 
          or1.Parameters.Add("WBBFEUCHTE", OracleType.NVarChar).Value = dwData["WBBFEUCHTE"].ToString(); 
          or1.Parameters.Add("WBBLIEFSCH", OracleType.NVarChar).Value = dwData["WBBLIEFSCH"].ToString(); 
          or1.Parameters.Add("WBBKDPART", OracleType.NVarChar).Value = dwData["WBBKDPART"].ToString(); 
          or1.Parameters.Add("WBBSCHLICHTEKZ", OracleType.NVarChar).Value = dwData["WBBSCHLICHTEKZ"].ToString(); 
          or1.Parameters.Add("WBBASWAKZ", OracleType.NVarChar).Value = dwData["WBBASWAKZ"].ToString(); 
          or1.Parameters.Add("WBBASART", OracleType.NVarChar).Value = dwData["WBBASART"].ToString(); 
          or1.Parameters.Add("WBBASVAR", OracleType.NVarChar).Value = dwData["WBBASVAR"].ToString(); 
          or1.Parameters.Add("WBBFARBEALT", OracleType.NVarChar).Value = dwData["WBBFARBEALT"].ToString(); 
          or1.Parameters.Add("WBBCOLALT", OracleType.NVarChar).Value = dwData["WBBCOLALT"].ToString(); 
          or1.Parameters.Add("WBBDESSALT", OracleType.NVarChar).Value = dwData["WBBDESSALT"].ToString(); 
          or1.Parameters.Add("WBBBESALT", OracleType.NVarChar).Value = dwData["WBBBESALT"].ToString(); 
          or1.Parameters.Add("WBBZUSTANDA", OracleType.NVarChar).Value = dwData["WBBZUSTANDA"].ToString(); 
          or1.Parameters.Add("WBBMASSKZ", OracleType.NVarChar).Value = dwData["WBBMASSKZ"].ToString(); 
          or1.Parameters.Add("WBBFJJJJ", OracleType.NVarChar).Value = dwData["WBBFJJJJ"].ToString(); 
          or1.Parameters.Add("WBBFBNR", OracleType.NVarChar).Value = dwData["WBBFBNR"].ToString(); 
          or1.Parameters.Add("WBBRETOURKZ", OracleType.NVarChar).Value = dwData["WBBRETOURKZ"].ToString(); 
          or1.Parameters.Add("WBBREAUFKRS", OracleType.NVarChar).Value = dwData["WBBREAUFKRS"].ToString(); 
          or1.Parameters.Add("WBBREAUFLFD", OracleType.NVarChar).Value = dwData["WBBREAUFLFD"].ToString(); 
          or1.Parameters.Add("WBBREAUFPOS", OracleType.NVarChar).Value = dwData["WBBREAUFPOS"].ToString(); 
          or1.Parameters.Add("WBBREAFOLGE", OracleType.NVarChar).Value = dwData["WBBREAFOLGE"].ToString(); 
          or1.Parameters.Add("WBBTPA", OracleType.NVarChar).Value = dwData["WBBTPA"].ToString(); 
          or1.Parameters.Add("WBBKOMMNR", OracleType.NVarChar).Value = dwData["WBBKOMMNR"].ToString(); 
          or1.Parameters.Add("WBBALIEFSCH", OracleType.NVarChar).Value = dwData["WBBALIEFSCH"].ToString(); 
          or1.Parameters.Add("WBBPACKNR", OracleType.NVarChar).Value = dwData["WBBPACKNR"].ToString(); 
          or1.Parameters.Add("WBBPACKAUTO", OracleType.NVarChar).Value = dwData["WBBPACKAUTO"].ToString(); 
          or1.Parameters.Add("WBBRUEKZ", OracleType.NVarChar).Value = dwData["WBBRUEKZ"].ToString(); 
          or1.Parameters.Add("WBBURLB", OracleType.NVarChar).Value = dwData["WBBURLB"].ToString(); 
          or1.Parameters.Add("WBBURLP", OracleType.NVarChar).Value = dwData["WBBURLP"].ToString(); 
          or1.Parameters.Add("WBBURAKZ", OracleType.NVarChar).Value = dwData["WBBURAKZ"].ToString(); 
          or1.Parameters.Add("WBBVERSDAT", OracleType.NVarChar).Value = dwData["WBBVERSDAT"].ToString(); 
          or1.Parameters.Add("WBBVERSANDKZ", OracleType.NVarChar).Value = dwData["WBBVERSANDKZ"].ToString(); 
          or1.Parameters.Add("WBBURLIEFSCH", OracleType.NVarChar).Value = dwData["WBBURLIEFSCH"].ToString(); 
          or1.Parameters.Add("WBBARECHNR", OracleType.NVarChar).Value = dwData["WBBARECHNR"].ToString(); 
          or1.Parameters.Add("WBBFERTKZ", OracleType.NVarChar).Value = dwData["WBBFERTKZ"].ToString(); 
          or1.Parameters.Add("WBBEGKZ", OracleType.NVarChar).Value = dwData["WBBEGKZ"].ToString(); 
          or1.Parameters.Add("WBBBEM", OracleType.NVarChar).Value = dwData["WBBBEM"].ToString(); 
          or1.Parameters.Add("WBBTXSCHL", OracleType.NVarChar).Value = dwData["WBBTXSCHL"].ToString(); 
          or1.Parameters.Add("WBBHHK1", OracleType.NVarChar).Value = dwData["WBBHHK1"].ToString(); 
          or1.Parameters.Add("WBBHHK2", OracleType.NVarChar).Value = dwData["WBBHHK2"].ToString(); 
          or1.Parameters.Add("WBBHHK3", OracleType.NVarChar).Value = dwData["WBBHHK3"].ToString(); 
          or1.Parameters.Add("WBBHHK4", OracleType.NVarChar).Value = dwData["WBBHHK4"].ToString(); 
          or1.Parameters.Add("WBBHHK5", OracleType.NVarChar).Value = dwData["WBBHHK5"].ToString(); 
          or1.Parameters.Add("WBBHHK6", OracleType.NVarChar).Value = dwData["WBBHHK6"].ToString(); 
          or1.Parameters.Add("WBBHHK7", OracleType.NVarChar).Value = dwData["WBBHHK7"].ToString(); 
          or1.Parameters.Add("WBBHHK8", OracleType.NVarChar).Value = dwData["WBBHHK8"].ToString(); 
          or1.Parameters.Add("WBBHHK9", OracleType.NVarChar).Value = dwData["WBBHHK9"].ToString(); 
          or1.Parameters.Add("WBBHHK10", OracleType.NVarChar).Value = dwData["WBBHHK10"].ToString(); 
          or1.Parameters.Add("WBBHHKG", OracleType.NVarChar).Value = dwData["WBBHHKG"].ToString(); 
          or1.Parameters.Add("WBBAHK1", OracleType.NVarChar).Value = dwData["WBBAHK1"].ToString(); 
          or1.Parameters.Add("WBBAHK2", OracleType.NVarChar).Value = dwData["WBBAHK2"].ToString(); 
          or1.Parameters.Add("WBBAHK3", OracleType.NVarChar).Value = dwData["WBBAHK3"].ToString(); 
          or1.Parameters.Add("WBBAHK4", OracleType.NVarChar).Value = dwData["WBBAHK4"].ToString(); 
          or1.Parameters.Add("WBBAHK5", OracleType.NVarChar).Value = dwData["WBBAHK5"].ToString(); 
          or1.Parameters.Add("WBBAHK6", OracleType.NVarChar).Value = dwData["WBBAHK6"].ToString(); 
          or1.Parameters.Add("WBBAHK7", OracleType.NVarChar).Value = dwData["WBBAHK7"].ToString(); 
          or1.Parameters.Add("WBBAHK8", OracleType.NVarChar).Value = dwData["WBBAHK8"].ToString(); 
          or1.Parameters.Add("WBBAHK9", OracleType.NVarChar).Value = dwData["WBBAHK9"].ToString(); 
          or1.Parameters.Add("WBBAHK10", OracleType.NVarChar).Value = dwData["WBBAHK10"].ToString(); 
          or1.Parameters.Add("WBBAHKG", OracleType.NVarChar).Value = dwData["WBBAHKG"].ToString(); 
          or1.Parameters.Add("WBBABPZAB", OracleType.NVarChar).Value = dwData["WBBABPZAB"].ToString(); 
          or1.Parameters.Add("WBBABDATAB", OracleType.NVarChar).Value = dwData["WBBABDATAB"].ToString(); 
          or1.Parameters.Add("WBBNEUBEN", OracleType.NVarChar).Value = dwData["WBBNEUBEN"].ToString(); 
          or1.Parameters.Add("WBBNEUDAT", OracleType.NVarChar).Value = dwData["WBBNEUDAT"].ToString(); 
          or1.Parameters.Add("WBBAENDBEN", OracleType.NVarChar).Value = dwData["WBBAENDBEN"].ToString(); 
          or1.Parameters.Add("WBBAENDDAT", OracleType.NVarChar).Value = dwData["WBBAENDDAT"].ToString(); 
          or1.Parameters.Add("WBBAENDZL", OracleType.NVarChar).Value = dwData["WBBAENDZL"].ToString(); 
          or1.Parameters.Add("WBBWS", OracleType.NVarChar).Value = dwData["WBBWS"].ToString(); 
          or1.Parameters.Add("WBBWSNO", OracleType.NVarChar).Value = dwData["WBBWSNO"].ToString(); 
          or1.Parameters.Add("WBBREFSCHL", OracleType.NVarChar).Value = dwData["WBBREFSCHL"].ToString(); 
          or1.Parameters.Add("WBBRSFSCHL", OracleType.NVarChar).Value = dwData["WBBRSFSCHL"].ToString(); 
          or1.Parameters.Add("WBBVEFSCHL", OracleType.NVarChar).Value = dwData["WBBVEFSCHL"].ToString(); 
          or1.Parameters.Add("WBBVSFSCHL", OracleType.NVarChar).Value = dwData["WBBVSFSCHL"].ToString(); 
          or1.Parameters.Add("WBBGRAM", OracleType.NVarChar).Value = dwData["WBBGRAM"].ToString(); 
          or1.Parameters.Add("WBBLAEKAT", OracleType.NVarChar).Value = dwData["WBBLAEKAT"].ToString(); 
          or1.Parameters.Add("WBBBRTKAT", OracleType.NVarChar).Value = dwData["WBBBRTKAT"].ToString(); 
          or1.Parameters.Add("WBBFRTAUFKRS", OracleType.NVarChar).Value = dwData["WBBFRTAUFKRS"].ToString(); 
          or1.Parameters.Add("WBBFRTAUFLFD", OracleType.NVarChar).Value = dwData["WBBFRTAUFLFD"].ToString(); 
          or1.Parameters.Add("WBBFRTAUFPOS", OracleType.NVarChar).Value = dwData["WBBFRTAUFPOS"].ToString(); 
          or1.Parameters.Add("WBBSPEZKAT", OracleType.NVarChar).Value = dwData["WBBSPEZKAT"].ToString(); 
          or1.Parameters.Add("WBBFILLER", OracleType.NVarChar).Value = dwData["WBBFILLER"].ToString(); 
                    #endregion
                    break; 
                default:
                    break;
            }


            Connect2Proxy(or1);
        }
    }
}
